|
|
|
|
- Enabling the management of integrity
- Disabling the integrity rules
- In HFSQL Client/Server mode
<Connection variable>.SetIntegrity (Function) In french: <Variable Connexion>.GèreIntégrité
Available only with these kinds of connection
Enables or disables the management of an integrity constraint on a file link. Remark: By default, all integrity rules defined in the analysis description are enabled. // Disable integrity rules on the link between an order and a customer // with use of a connection CtSourceFile is Connection CtLinkedFile is Connection  CtSourceFile.SetIntegrity(CtLinkedFile, CustomerOrder, ... hCardinality + hOnUpdate + hOnDelete, False)
Enabling or disabling the management of an integrity constraint by specifying the connection of data file Hide the details
<Result> = <Source data file connection>.SetIntegrity([<Linked data file connection>, ] <Link description> [, <Integrity constraint>] , <Management mode>)
<Result>: Boolean Former management mode of integrity (before the call to <Connection variable>.SetIntegrity): - True if the management of integrity was enabled,
- False if the management of integrity was disabled.
<Source data file connection>: Connection variable Name of the Connection variable that describes the connection to which the link source data file belongs. <Linked data file connection>: Connection variable Name of the Connection variable that describes the connection to which the linked file of the link belongs. <Link description>: Link Description variable Name of the Link description variable that contains the characteristics of the link. <Integrity constraint>: Optional Integer constant (or combination of constants) Integrity constraints that must be managed. If this parameter is not specified, the new management mode is applied to all link constraints. | | hCardinality | Check the link cardinalities. | hOnDelete | Integrity rule applied during a deletion. | hOnUpdate | Integrity rule applied during a modification. |
<Management mode>: Boolean - True if the integrity constraint is enabled,
- False if this management must be disabled. If only this parameter is specified, the management mode is applied to all data files.
Remarks Enabling the management of integrity If an operation performed on a data file triggers a violation of an integrity constraint on an active rule, the operation is not performed and provokes the error of the function. In this case, HErrorIntegrity returns True. Disabling the integrity rules Disabling an integrity rule means the possibility not to comply with the constraints specified during the description of the data files in the data model editor. Therefore, disabling an integrity rule should be done with great care: it must be used advisedly.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|